package com.desksoft.ecommerce.entity.mall.dto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.desksoft.ecommerce.base.Entity;

public class QuoterecordExample implements Entity{
    /***************************************
	 * <pre>
	 * 版权所有：杭州迪科软件 保留所有权利
	 * 创建日期: @date 2012-11-23 上午09:59:12
	 * 创建作者：jh
	 * 文件名称：QuoterecordExample.java
	 * 版本：1.0
	 * 功能：
	 * 最后修改时间：
	 * 修改记录：
	 * </pre>
	 *****************************************/
	private static final long serialVersionUID = 9217705314301130671L;

	 protected String orderByClause;

	    protected boolean distinct;

	    protected List<Criteria> oredCriteria;

	    public QuoterecordExample() {
	        oredCriteria = new ArrayList<Criteria>();
	    }

	    public void setOrderByClause(String orderByClause) {
	        this.orderByClause = orderByClause;
	    }

	    public String getOrderByClause() {
	        return orderByClause;
	    }

	    public void setDistinct(boolean distinct) {
	        this.distinct = distinct;
	    }

	    public boolean isDistinct() {
	        return distinct;
	    }

	    public List<Criteria> getOredCriteria() {
	        return oredCriteria;
	    }

	    public void or(Criteria criteria) {
	        oredCriteria.add(criteria);
	    }

	    public Criteria or() {
	        Criteria criteria = createCriteriaInternal();
	        oredCriteria.add(criteria);
	        return criteria;
	    }

	    public Criteria createCriteria() {
	        Criteria criteria = createCriteriaInternal();
	        if (oredCriteria.size() == 0) {
	            oredCriteria.add(criteria);
	        }
	        return criteria;
	    }

	    protected Criteria createCriteriaInternal() {
	        Criteria criteria = new Criteria();
	        return criteria;
	    }

	    public void clear() {
	        oredCriteria.clear();
	        orderByClause = null;
	        distinct = false;
	    }

	    protected abstract static class GeneratedCriteria {
	        protected List<Criterion> criteria;

	        protected GeneratedCriteria() {
	            super();
	            criteria = new ArrayList<Criterion>();
	        }

	        public boolean isValid() {
	            return criteria.size() > 0;
	        }

	        public List<Criterion> getAllCriteria() {
	            return criteria;
	        }

	        public List<Criterion> getCriteria() {
	            return criteria;
	        }

	        protected void addCriterion(String condition) {
	            if (condition == null) {
	                throw new RuntimeException("Value for condition cannot be null");
	            }
	            criteria.add(new Criterion(condition));
	        }

	        protected void addCriterion(String condition, Object value, String property) {
	            if (value == null) {
	                throw new RuntimeException("Value for " + property + " cannot be null");
	            }
	            criteria.add(new Criterion(condition, value));
	        }

	        protected void addCriterion(String condition, Object value1, Object value2, String property) {
	            if (value1 == null || value2 == null) {
	                throw new RuntimeException("Between values for " + property + " cannot be null");
	            }
	            criteria.add(new Criterion(condition, value1, value2));
	        }

	        public Criteria andIdIsNull() {
	            addCriterion("ID is null");
	            return (Criteria) this;
	        }

	        public Criteria andIdIsNotNull() {
	            addCriterion("ID is not null");
	            return (Criteria) this;
	        }

	        public Criteria andIdEqualTo(Integer value) {
	            addCriterion("ID =", value, "id");
	            return (Criteria) this;
	        }

	        public Criteria andIdNotEqualTo(Integer value) {
	            addCriterion("ID <>", value, "id");
	            return (Criteria) this;
	        }

	        public Criteria andIdGreaterThan(Integer value) {
	            addCriterion("ID >", value, "id");
	            return (Criteria) this;
	        }

	        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
	            addCriterion("ID >=", value, "id");
	            return (Criteria) this;
	        }

	        public Criteria andIdLessThan(Integer value) {
	            addCriterion("ID <", value, "id");
	            return (Criteria) this;
	        }

	        public Criteria andIdLessThanOrEqualTo(Integer value) {
	            addCriterion("ID <=", value, "id");
	            return (Criteria) this;
	        }

	        public Criteria andIdIn(List<Integer> values) {
	            addCriterion("ID in", values, "id");
	            return (Criteria) this;
	        }

	        public Criteria andIdNotIn(List<Integer> values) {
	            addCriterion("ID not in", values, "id");
	            return (Criteria) this;
	        }

	        public Criteria andIdBetween(Integer value1, Integer value2) {
	            addCriterion("ID between", value1, value2, "id");
	            return (Criteria) this;
	        }

	        public Criteria andIdNotBetween(Integer value1, Integer value2) {
	            addCriterion("ID not between", value1, value2, "id");
	            return (Criteria) this;
	        }

	        public Criteria andSiteidIsNull() {
	            addCriterion("SiteID is null");
	            return (Criteria) this;
	        }

	        public Criteria andSiteidIsNotNull() {
	            addCriterion("SiteID is not null");
	            return (Criteria) this;
	        }

	        public Criteria andSiteidEqualTo(Integer value) {
	            addCriterion("SiteID =", value, "siteid");
	            return (Criteria) this;
	        }

	        public Criteria andSiteidNotEqualTo(Integer value) {
	            addCriterion("SiteID <>", value, "siteid");
	            return (Criteria) this;
	        }

	        public Criteria andSiteidGreaterThan(Integer value) {
	            addCriterion("SiteID >", value, "siteid");
	            return (Criteria) this;
	        }

	        public Criteria andSiteidGreaterThanOrEqualTo(Integer value) {
	            addCriterion("SiteID >=", value, "siteid");
	            return (Criteria) this;
	        }

	        public Criteria andSiteidLessThan(Integer value) {
	            addCriterion("SiteID <", value, "siteid");
	            return (Criteria) this;
	        }

	        public Criteria andSiteidLessThanOrEqualTo(Integer value) {
	            addCriterion("SiteID <=", value, "siteid");
	            return (Criteria) this;
	        }

	        public Criteria andSiteidIn(List<Integer> values) {
	            addCriterion("SiteID in", values, "siteid");
	            return (Criteria) this;
	        }

	        public Criteria andSiteidNotIn(List<Integer> values) {
	            addCriterion("SiteID not in", values, "siteid");
	            return (Criteria) this;
	        }

	        public Criteria andSiteidBetween(Integer value1, Integer value2) {
	            addCriterion("SiteID between", value1, value2, "siteid");
	            return (Criteria) this;
	        }

	        public Criteria andSiteidNotBetween(Integer value1, Integer value2) {
	            addCriterion("SiteID not between", value1, value2, "siteid");
	            return (Criteria) this;
	        }

	        public Criteria andCardnoIsNull() {
	            addCriterion("CardNo is null");
	            return (Criteria) this;
	        }

	        public Criteria andCardnoIsNotNull() {
	            addCriterion("CardNo is not null");
	            return (Criteria) this;
	        }

	        public Criteria andCardnoEqualTo(String value) {
	            addCriterion("CardNo =", value, "cardno");
	            return (Criteria) this;
	        }

	        public Criteria andCardnoNotEqualTo(String value) {
	            addCriterion("CardNo <>", value, "cardno");
	            return (Criteria) this;
	        }

	        public Criteria andCardnoGreaterThan(String value) {
	            addCriterion("CardNo >", value, "cardno");
	            return (Criteria) this;
	        }

	        public Criteria andCardnoGreaterThanOrEqualTo(String value) {
	            addCriterion("CardNo >=", value, "cardno");
	            return (Criteria) this;
	        }

	        public Criteria andCardnoLessThan(String value) {
	            addCriterion("CardNo <", value, "cardno");
	            return (Criteria) this;
	        }

	        public Criteria andCardnoLessThanOrEqualTo(String value) {
	            addCriterion("CardNo <=", value, "cardno");
	            return (Criteria) this;
	        }

	        public Criteria andCardnoLike(String value) {
	            addCriterion("CardNo like", value, "cardno");
	            return (Criteria) this;
	        }

	        public Criteria andCardnoNotLike(String value) {
	            addCriterion("CardNo not like", value, "cardno");
	            return (Criteria) this;
	        }

	        public Criteria andCardnoIn(List<String> values) {
	            addCriterion("CardNo in", values, "cardno");
	            return (Criteria) this;
	        }

	        public Criteria andCardnoNotIn(List<String> values) {
	            addCriterion("CardNo not in", values, "cardno");
	            return (Criteria) this;
	        }

	        public Criteria andCardnoBetween(String value1, String value2) {
	            addCriterion("CardNo between", value1, value2, "cardno");
	            return (Criteria) this;
	        }

	        public Criteria andCardnoNotBetween(String value1, String value2) {
	            addCriterion("CardNo not between", value1, value2, "cardno");
	            return (Criteria) this;
	        }

	        public Criteria andPriceIsNull() {
	            addCriterion("Price is null");
	            return (Criteria) this;
	        }

	        public Criteria andPriceIsNotNull() {
	            addCriterion("Price is not null");
	            return (Criteria) this;
	        }

	        public Criteria andPriceEqualTo(BigDecimal value) {
	            addCriterion("Price =", value, "price");
	            return (Criteria) this;
	        }

	        public Criteria andPriceNotEqualTo(BigDecimal value) {
	            addCriterion("Price <>", value, "price");
	            return (Criteria) this;
	        }

	        public Criteria andPriceGreaterThan(BigDecimal value) {
	            addCriterion("Price >", value, "price");
	            return (Criteria) this;
	        }

	        public Criteria andPriceGreaterThanOrEqualTo(BigDecimal value) {
	            addCriterion("Price >=", value, "price");
	            return (Criteria) this;
	        }

	        public Criteria andPriceLessThan(BigDecimal value) {
	            addCriterion("Price <", value, "price");
	            return (Criteria) this;
	        }

	        public Criteria andPriceLessThanOrEqualTo(BigDecimal value) {
	            addCriterion("Price <=", value, "price");
	            return (Criteria) this;
	        }

	        public Criteria andPriceIn(List<BigDecimal> values) {
	            addCriterion("Price in", values, "price");
	            return (Criteria) this;
	        }

	        public Criteria andPriceNotIn(List<BigDecimal> values) {
	            addCriterion("Price not in", values, "price");
	            return (Criteria) this;
	        }

	        public Criteria andPriceBetween(BigDecimal value1, BigDecimal value2) {
	            addCriterion("Price between", value1, value2, "price");
	            return (Criteria) this;
	        }

	        public Criteria andPriceNotBetween(BigDecimal value1, BigDecimal value2) {
	            addCriterion("Price not between", value1, value2, "price");
	            return (Criteria) this;
	        }

	        public Criteria andItemcodeIsNull() {
	            addCriterion("ItemCode is null");
	            return (Criteria) this;
	        }

	        public Criteria andItemcodeIsNotNull() {
	            addCriterion("ItemCode is not null");
	            return (Criteria) this;
	        }

	        public Criteria andItemcodeEqualTo(String value) {
	            addCriterion("ItemCode =", value, "itemcode");
	            return (Criteria) this;
	        }

	        public Criteria andItemcodeNotEqualTo(String value) {
	            addCriterion("ItemCode <>", value, "itemcode");
	            return (Criteria) this;
	        }

	        public Criteria andItemcodeGreaterThan(String value) {
	            addCriterion("ItemCode >", value, "itemcode");
	            return (Criteria) this;
	        }

	        public Criteria andItemcodeGreaterThanOrEqualTo(String value) {
	            addCriterion("ItemCode >=", value, "itemcode");
	            return (Criteria) this;
	        }

	        public Criteria andItemcodeLessThan(String value) {
	            addCriterion("ItemCode <", value, "itemcode");
	            return (Criteria) this;
	        }

	        public Criteria andItemcodeLessThanOrEqualTo(String value) {
	            addCriterion("ItemCode <=", value, "itemcode");
	            return (Criteria) this;
	        }

	        public Criteria andItemcodeLike(String value) {
	            addCriterion("ItemCode like", value, "itemcode");
	            return (Criteria) this;
	        }

	        public Criteria andItemcodeNotLike(String value) {
	            addCriterion("ItemCode not like", value, "itemcode");
	            return (Criteria) this;
	        }

	        public Criteria andItemcodeIn(List<String> values) {
	            addCriterion("ItemCode in", values, "itemcode");
	            return (Criteria) this;
	        }

	        public Criteria andItemcodeNotIn(List<String> values) {
	            addCriterion("ItemCode not in", values, "itemcode");
	            return (Criteria) this;
	        }

	        public Criteria andItemcodeBetween(String value1, String value2) {
	            addCriterion("ItemCode between", value1, value2, "itemcode");
	            return (Criteria) this;
	        }

	        public Criteria andItemcodeNotBetween(String value1, String value2) {
	            addCriterion("ItemCode not between", value1, value2, "itemcode");
	            return (Criteria) this;
	        }

	        public Criteria andGmtsubmitdateIsNull() {
	            addCriterion("GmtSubmitDate is null");
	            return (Criteria) this;
	        }

	        public Criteria andGmtsubmitdateIsNotNull() {
	            addCriterion("GmtSubmitDate is not null");
	            return (Criteria) this;
	        }

	        public Criteria andGmtsubmitdateEqualTo(Date value) {
	            addCriterion("GmtSubmitDate =", value, "gmtsubmitdate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtsubmitdateNotEqualTo(Date value) {
	            addCriterion("GmtSubmitDate <>", value, "gmtsubmitdate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtsubmitdateGreaterThan(Date value) {
	            addCriterion("GmtSubmitDate >", value, "gmtsubmitdate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtsubmitdateGreaterThanOrEqualTo(Date value) {
	            addCriterion("GmtSubmitDate >=", value, "gmtsubmitdate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtsubmitdateLessThan(Date value) {
	            addCriterion("GmtSubmitDate <", value, "gmtsubmitdate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtsubmitdateLessThanOrEqualTo(Date value) {
	            addCriterion("GmtSubmitDate <=", value, "gmtsubmitdate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtsubmitdateIn(List<Date> values) {
	            addCriterion("GmtSubmitDate in", values, "gmtsubmitdate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtsubmitdateNotIn(List<Date> values) {
	            addCriterion("GmtSubmitDate not in", values, "gmtsubmitdate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtsubmitdateBetween(Date value1, Date value2) {
	            addCriterion("GmtSubmitDate between", value1, value2, "gmtsubmitdate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtsubmitdateNotBetween(Date value1, Date value2) {
	            addCriterion("GmtSubmitDate not between", value1, value2, "gmtsubmitdate");
	            return (Criteria) this;
	        }

	        public Criteria andStatusIsNull() {
	            addCriterion("Status is null");
	            return (Criteria) this;
	        }

	        public Criteria andStatusIsNotNull() {
	            addCriterion("Status is not null");
	            return (Criteria) this;
	        }

	        public Criteria andStatusEqualTo(Short value) {
	            addCriterion("Status =", value, "status");
	            return (Criteria) this;
	        }

	        public Criteria andStatusNotEqualTo(Short value) {
	            addCriterion("Status <>", value, "status");
	            return (Criteria) this;
	        }

	        public Criteria andStatusGreaterThan(Short value) {
	            addCriterion("Status >", value, "status");
	            return (Criteria) this;
	        }

	        public Criteria andStatusGreaterThanOrEqualTo(Short value) {
	            addCriterion("Status >=", value, "status");
	            return (Criteria) this;
	        }

	        public Criteria andStatusLessThan(Short value) {
	            addCriterion("Status <", value, "status");
	            return (Criteria) this;
	        }

	        public Criteria andStatusLessThanOrEqualTo(Short value) {
	            addCriterion("Status <=", value, "status");
	            return (Criteria) this;
	        }

	        public Criteria andStatusIn(List<Short> values) {
	            addCriterion("Status in", values, "status");
	            return (Criteria) this;
	        }

	        public Criteria andStatusNotIn(List<Short> values) {
	            addCriterion("Status not in", values, "status");
	            return (Criteria) this;
	        }

	        public Criteria andStatusBetween(Short value1, Short value2) {
	            addCriterion("Status between", value1, value2, "status");
	            return (Criteria) this;
	        }

	        public Criteria andStatusNotBetween(Short value1, Short value2) {
	            addCriterion("Status not between", value1, value2, "status");
	            return (Criteria) this;
	        }

	        public Criteria andReplyuserIsNull() {
	            addCriterion("ReplyUser is null");
	            return (Criteria) this;
	        }

	        public Criteria andReplyuserIsNotNull() {
	            addCriterion("ReplyUser is not null");
	            return (Criteria) this;
	        }

	        public Criteria andReplyuserEqualTo(String value) {
	            addCriterion("ReplyUser =", value, "replyuser");
	            return (Criteria) this;
	        }

	        public Criteria andReplyuserNotEqualTo(String value) {
	            addCriterion("ReplyUser <>", value, "replyuser");
	            return (Criteria) this;
	        }

	        public Criteria andReplyuserGreaterThan(String value) {
	            addCriterion("ReplyUser >", value, "replyuser");
	            return (Criteria) this;
	        }

	        public Criteria andReplyuserGreaterThanOrEqualTo(String value) {
	            addCriterion("ReplyUser >=", value, "replyuser");
	            return (Criteria) this;
	        }

	        public Criteria andReplyuserLessThan(String value) {
	            addCriterion("ReplyUser <", value, "replyuser");
	            return (Criteria) this;
	        }

	        public Criteria andReplyuserLessThanOrEqualTo(String value) {
	            addCriterion("ReplyUser <=", value, "replyuser");
	            return (Criteria) this;
	        }

	        public Criteria andReplyuserLike(String value) {
	            addCriterion("ReplyUser like", value, "replyuser");
	            return (Criteria) this;
	        }

	        public Criteria andReplyuserNotLike(String value) {
	            addCriterion("ReplyUser not like", value, "replyuser");
	            return (Criteria) this;
	        }

	        public Criteria andReplyuserIn(List<String> values) {
	            addCriterion("ReplyUser in", values, "replyuser");
	            return (Criteria) this;
	        }

	        public Criteria andReplyuserNotIn(List<String> values) {
	            addCriterion("ReplyUser not in", values, "replyuser");
	            return (Criteria) this;
	        }

	        public Criteria andReplyuserBetween(String value1, String value2) {
	            addCriterion("ReplyUser between", value1, value2, "replyuser");
	            return (Criteria) this;
	        }

	        public Criteria andReplyuserNotBetween(String value1, String value2) {
	            addCriterion("ReplyUser not between", value1, value2, "replyuser");
	            return (Criteria) this;
	        }

	        public Criteria andGmtreplydateIsNull() {
	            addCriterion("GmtReplyDate is null");
	            return (Criteria) this;
	        }

	        public Criteria andGmtreplydateIsNotNull() {
	            addCriterion("GmtReplyDate is not null");
	            return (Criteria) this;
	        }

	        public Criteria andGmtreplydateEqualTo(Date value) {
	            addCriterion("GmtReplyDate =", value, "gmtreplydate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtreplydateNotEqualTo(Date value) {
	            addCriterion("GmtReplyDate <>", value, "gmtreplydate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtreplydateGreaterThan(Date value) {
	            addCriterion("GmtReplyDate >", value, "gmtreplydate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtreplydateGreaterThanOrEqualTo(Date value) {
	            addCriterion("GmtReplyDate >=", value, "gmtreplydate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtreplydateLessThan(Date value) {
	            addCriterion("GmtReplyDate <", value, "gmtreplydate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtreplydateLessThanOrEqualTo(Date value) {
	            addCriterion("GmtReplyDate <=", value, "gmtreplydate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtreplydateIn(List<Date> values) {
	            addCriterion("GmtReplyDate in", values, "gmtreplydate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtreplydateNotIn(List<Date> values) {
	            addCriterion("GmtReplyDate not in", values, "gmtreplydate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtreplydateBetween(Date value1, Date value2) {
	            addCriterion("GmtReplyDate between", value1, value2, "gmtreplydate");
	            return (Criteria) this;
	        }

	        public Criteria andGmtreplydateNotBetween(Date value1, Date value2) {
	            addCriterion("GmtReplyDate not between", value1, value2, "gmtreplydate");
	            return (Criteria) this;
	        }

	        public Criteria andItemnameIsNull() {
	            addCriterion("ItemName is null");
	            return (Criteria) this;
	        }

	        public Criteria andItemnameIsNotNull() {
	            addCriterion("ItemName is not null");
	            return (Criteria) this;
	        }

	        public Criteria andItemnameEqualTo(String value) {
	            addCriterion("ItemName =", value, "itemname");
	            return (Criteria) this;
	        }

	        public Criteria andItemnameNotEqualTo(String value) {
	            addCriterion("ItemName <>", value, "itemname");
	            return (Criteria) this;
	        }

	        public Criteria andItemnameGreaterThan(String value) {
	            addCriterion("ItemName >", value, "itemname");
	            return (Criteria) this;
	        }

	        public Criteria andItemnameGreaterThanOrEqualTo(String value) {
	            addCriterion("ItemName >=", value, "itemname");
	            return (Criteria) this;
	        }

	        public Criteria andItemnameLessThan(String value) {
	            addCriterion("ItemName <", value, "itemname");
	            return (Criteria) this;
	        }

	        public Criteria andItemnameLessThanOrEqualTo(String value) {
	            addCriterion("ItemName <=", value, "itemname");
	            return (Criteria) this;
	        }

	        public Criteria andItemnameLike(String value) {
	            addCriterion("ItemName like", value, "itemname");
	            return (Criteria) this;
	        }

	        public Criteria andItemnameNotLike(String value) {
	            addCriterion("ItemName not like", value, "itemname");
	            return (Criteria) this;
	        }

	        public Criteria andItemnameIn(List<String> values) {
	            addCriterion("ItemName in", values, "itemname");
	            return (Criteria) this;
	        }

	        public Criteria andItemnameNotIn(List<String> values) {
	            addCriterion("ItemName not in", values, "itemname");
	            return (Criteria) this;
	        }

	        public Criteria andItemnameBetween(String value1, String value2) {
	            addCriterion("ItemName between", value1, value2, "itemname");
	            return (Criteria) this;
	        }

	        public Criteria andItemnameNotBetween(String value1, String value2) {
	            addCriterion("ItemName not between", value1, value2, "itemname");
	            return (Criteria) this;
	        }

	        public Criteria andUsernameIsNull() {
	            addCriterion("UserName is null");
	            return (Criteria) this;
	        }

	        public Criteria andUsernameIsNotNull() {
	            addCriterion("UserName is not null");
	            return (Criteria) this;
	        }

	        public Criteria andUsernameEqualTo(String value) {
	            addCriterion("UserName =", value, "username");
	            return (Criteria) this;
	        }

	        public Criteria andUsernameNotEqualTo(String value) {
	            addCriterion("UserName <>", value, "username");
	            return (Criteria) this;
	        }

	        public Criteria andUsernameGreaterThan(String value) {
	            addCriterion("UserName >", value, "username");
	            return (Criteria) this;
	        }

	        public Criteria andUsernameGreaterThanOrEqualTo(String value) {
	            addCriterion("UserName >=", value, "username");
	            return (Criteria) this;
	        }

	        public Criteria andUsernameLessThan(String value) {
	            addCriterion("UserName <", value, "username");
	            return (Criteria) this;
	        }

	        public Criteria andUsernameLessThanOrEqualTo(String value) {
	            addCriterion("UserName <=", value, "username");
	            return (Criteria) this;
	        }

	        public Criteria andUsernameLike(String value) {
	            addCriterion("UserName like", value, "username");
	            return (Criteria) this;
	        }

	        public Criteria andUsernameNotLike(String value) {
	            addCriterion("UserName not like", value, "username");
	            return (Criteria) this;
	        }

	        public Criteria andUsernameIn(List<String> values) {
	            addCriterion("UserName in", values, "username");
	            return (Criteria) this;
	        }

	        public Criteria andUsernameNotIn(List<String> values) {
	            addCriterion("UserName not in", values, "username");
	            return (Criteria) this;
	        }

	        public Criteria andUsernameBetween(String value1, String value2) {
	            addCriterion("UserName between", value1, value2, "username");
	            return (Criteria) this;
	        }

	        public Criteria andUsernameNotBetween(String value1, String value2) {
	            addCriterion("UserName not between", value1, value2, "username");
	            return (Criteria) this;
	        }

	        public Criteria andOpteridIsNull() {
	            addCriterion("opterID is null");
	            return (Criteria) this;
	        }

	        public Criteria andOpteridIsNotNull() {
	            addCriterion("opterID is not null");
	            return (Criteria) this;
	        }

	        public Criteria andOpteridEqualTo(String value) {
	            addCriterion("opterID =", value, "opterid");
	            return (Criteria) this;
	        }

	        public Criteria andOpteridNotEqualTo(String value) {
	            addCriterion("opterID <>", value, "opterid");
	            return (Criteria) this;
	        }

	        public Criteria andOpteridGreaterThan(String value) {
	            addCriterion("opterID >", value, "opterid");
	            return (Criteria) this;
	        }

	        public Criteria andOpteridGreaterThanOrEqualTo(String value) {
	            addCriterion("opterID >=", value, "opterid");
	            return (Criteria) this;
	        }

	        public Criteria andOpteridLessThan(String value) {
	            addCriterion("opterID <", value, "opterid");
	            return (Criteria) this;
	        }

	        public Criteria andOpteridLessThanOrEqualTo(String value) {
	            addCriterion("opterID <=", value, "opterid");
	            return (Criteria) this;
	        }

	        public Criteria andOpteridLike(String value) {
	            addCriterion("opterID like", value, "opterid");
	            return (Criteria) this;
	        }

	        public Criteria andOpteridNotLike(String value) {
	            addCriterion("opterID not like", value, "opterid");
	            return (Criteria) this;
	        }

	        public Criteria andOpteridIn(List<String> values) {
	            addCriterion("opterID in", values, "opterid");
	            return (Criteria) this;
	        }

	        public Criteria andOpteridNotIn(List<String> values) {
	            addCriterion("opterID not in", values, "opterid");
	            return (Criteria) this;
	        }

	        public Criteria andOpteridBetween(String value1, String value2) {
	            addCriterion("opterID between", value1, value2, "opterid");
	            return (Criteria) this;
	        }

	        public Criteria andOpteridNotBetween(String value1, String value2) {
	            addCriterion("opterID not between", value1, value2, "opterid");
	            return (Criteria) this;
	        }
	    }

	    public static class Criteria extends GeneratedCriteria {

	        protected Criteria() {
	            super();
	        }
	    }

	    public static class Criterion {
	        private String condition;

	        private Object value;

	        private Object secondValue;

	        private boolean noValue;

	        private boolean singleValue;

	        private boolean betweenValue;

	        private boolean listValue;

	        private String typeHandler;

	        public String getCondition() {
	            return condition;
	        }

	        public Object getValue() {
	            return value;
	        }

	        public Object getSecondValue() {
	            return secondValue;
	        }

	        public boolean isNoValue() {
	            return noValue;
	        }

	        public boolean isSingleValue() {
	            return singleValue;
	        }

	        public boolean isBetweenValue() {
	            return betweenValue;
	        }

	        public boolean isListValue() {
	            return listValue;
	        }

	        public String getTypeHandler() {
	            return typeHandler;
	        }

	        protected Criterion(String condition) {
	            super();
	            this.condition = condition;
	            this.typeHandler = null;
	            this.noValue = true;
	        }

	        protected Criterion(String condition, Object value, String typeHandler) {
	            super();
	            this.condition = condition;
	            this.value = value;
	            this.typeHandler = typeHandler;
	            if (value instanceof List<?>) {
	                this.listValue = true;
	            } else {
	                this.singleValue = true;
	            }
	        }

	        protected Criterion(String condition, Object value) {
	            this(condition, value, null);
	        }

	        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
	            super();
	            this.condition = condition;
	            this.value = value;
	            this.secondValue = secondValue;
	            this.typeHandler = typeHandler;
	            this.betweenValue = true;
	        }

	        protected Criterion(String condition, Object value, Object secondValue) {
	            this(condition, value, secondValue, null);
	        }
	    }
}